1 <?php
2 include 'includes/connect.php';
3
4
5 if($_SESSION['admin_sid']==session_id())
6 {
7 ?>
8 <!DOCTYPE html>
9 <html lang="en">
10
11 <head>
12 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
13 <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1.0, user-scalable=no">
14 <meta http-equiv="X-UA-Compatible" content="IE=edge">
15 <meta name="msapplication-tap-highlight" content="no">
16 <title>User List</title>
17
18 <!-- Favicons-->
19 <link rel="icon" href="images/favicon/favicon-32x32.png" sizes="32x32">
20 <!-- Favicons-->
21 <link rel="apple-touch-icon-precomposed" href="images/favicon/apple-touch-icon-152x152.png">
22 <!-- For iPhone -->
23 <meta name="msapplication-TileColor" content="#00bcd4">
24 <meta name="msapplication-TileImage" content="images/favicon/mstile-144x144.png">
25 <!-- For Windows Phone -->
26
27
28 <!-- CORE CSS-->
29 <link href="css/materialize.min.css" type="text/css" rel="stylesheet" media="screen,projection">
30 <link href="css/style.min.css" type="text/css" rel="stylesheet" media="screen,projection">
31 <!-- Custome CSS-->
32 <link href="css/custom/custom.min.css" type="text/css" rel="stylesheet" media="screen,projection">
33
34 <link href="js/plugins/perfect-scrollbar/perfect-scrollbar.css" type="text/css" rel="stylesheet" media="screen,projection">
35 <style type="text/css">
36 .input-field div.error{
37 position: relative;
38 top: -1rem;
39 left: 0rem;
40 font-size: 0.8rem;
41 color:#FF4081;
42 -webkit-transform: translateY(0%);
43 -ms-transform: translateY(0%);
44 -o-transform: translateY(0%);
45 transform: translateY(0%);
46 }
47 .input-field label.active{
48 width:100%;
49 }
50 .left-alert input[type=text] + label:after,
51 .left-alert input[type=password] + label:after,
52 .left-alert input[type=email] + label:after,
53 .left-alert input[type=url] + label:after,
54 .left-alert input[type=time] + label:after,
55 .left-alert input[type=date] + label:after,
56 .left-alert input[type=datetime-local] + label:after,
57 .left-alert input[type=tel] + label:after,
58 .left-alert input[type=number] + label:after,
59 .left-alert input[type=search] + label:after,
60 .left-alert textarea.materialize-textarea + label:after{
61 left:0px;
62 }
63 .right-alert input[type=text] + label:after,
64 .right-alert input[type=password] + label:after,
65 .right-alert input[type=email] + label:after,
66 .right-alert input[type=url] + label:after,
67 .right-alert input[type=time] + label:after,
68 .right-alert input[type=date] + label:after,
69 .right-alert input[type=datetime-local] + label:after,
70 .right-alert input[type=tel] + label:after,
71 .right-alert input[type=number] + label:after,
72 .right-alert input[type=search] + label:after,
73 .right-alert textarea.materialize-textarea + label:after{
74 right:70px;
75 }
76 </style>
77 </head>
78
79 <body>
80 <!-- Start Page Loading -->
81 <div id="loader-wrapper">
82 <div id="loader"></div>
83 <div class="loader-section section-left"></div>
84 <div class="loader-section section-right"></div>
85 </div>
86 <!-- End Page Loading -->
87
88 <!-- //////////////////////////////////////////////////////////////////////////// -->
89
90 <!-- START HEADER -->
91 <header id="header" class="page-topbar">
92 <!-- start header nav-->
93 <div class="navbar-fixed">
94 <nav class="navbar-color">
95 <div class="nav-wrapper">
96 <ul class="left">
97 <li><h1 class="logo-wrapper"><a href="index.php" class="brand-logo darken-1"><img src="images/materialize-logo.png" alt="logo"></a> <span class="logo-text">Logo</span></h1></li>
98 </ul>
99 </div>
100 </nav>
101 </div>
102 <!-- end header nav-->
103 </header>
104 <!-- END HEADER -->
105
106 <!-- //////////////////////////////////////////////////////////////////////////// -->
107
108 <!-- START MAIN -->
109 <div id="main">
110 <!-- START WRAPPER -->
111 <div class="wrapper">
112
113 <!-- START LEFT SIDEBAR NAV-->
114 <aside id="left-sidebar-nav">
115 <ul id="slide-out" class="side-nav fixed leftside-navigation">
116 <li class="user-details cyan darken-2">
117 <div class="row">
118 <div class="col col s4 m4 l4">
119 <img src="images/avatar.jpg" alt="" class="circle responsive-img valign profile-image">
120 </div>
121 <div class="col col s8 m8 l8">
122 <ul id="profile-dropdown" class="dropdown-content">
123 <li><a href="routers/logout.php"><i class="mdi-hardware-keyboard-tab"></i> Logout</a>
124 </li>
125 </ul>
126 </div>
127 <div class="col col s8 m8 l8">
128 <a class="btn-flat dropdown-button waves-effect waves-light white-text profile-btn" href="#" data-activates="profile-dropdown"><?php echo $name;?> <i class="mdi-navigation-arrow-drop-down right"></i></a>
129 <p class="user-roal"><?php echo $role;?></p>
130 </div>
131 </div>
132 </li>
133 <li class="bold"><a href="index.php" class="waves-effect waves-cyan"><i class="mdi-editor-border-color"></i> Food Menu</a>
134 </li>
135 <li class="no-padding">
136 <ul class="collapsible collapsible-accordion">
137 <li class="bold"><a class="collapsible-header waves-effect waves-cyan"><i class="mdi-editor-insert-invitation"></i> Orders</a>
138 <div class="collapsible-body">
139 <ul>
140 <li><a href="all-orders.php">All Orders</a>
141 </li>
142 <?php
143 $sql = mysqli_query($con, "SELECT DISTINCT status FROM orders;");
144 while($row = mysqli_fetch_array($sql)){
145 echo '<li><a href="all-orders.php?status='.$row['status'].'">'.$row['status'].'</a>
146 </li>';
147 }
148 ?>
149 </ul>
150 </div>
151 </li>
152 </ul>
153 </li>
154 <li class="no-padding">
155 <ul class="collapsible collapsible-accordion">
156 <li class="bold"><a class="collapsible-header waves-effect waves-cyan"><i class="mdi-action-question-answer"></i> Tickets</a>
157 <div class="collapsible-body">
158 <ul>
159 <li><a href="all-tickets.php">All Tickets</a>
160 </li>
161 <?php
162 $sql = mysqli_query($con, "SELECT DISTINCT status FROM tickets;");
163 while($row = mysqli_fetch_array($sql)){
164 echo '<li><a href="all-tickets.php?status='.$row['status'].'">'.$row['status'].'</a>
165 </li>';
166 }
167 ?>
168 </ul>
169 </div>
170 </li>
171 </ul>
172 </li>
173 <li class="bold active"><a href="users.php" class="waves-effect waves-cyan"><i class="mdi-social-person"></i> Users</a>
174 </li>
175 </ul>
176 <a href="#" data-activates="slide-out" class="sidebar-collapse btn-floating btn-medium waves-effect waves-light hide-on-large-only cyan"><i class="mdi-navigation-menu"></i></a>
177 </aside>
178 <!-- END LEFT SIDEBAR NAV-->
179
180 <!-- //////////////////////////////////////////////////////////////////////////// -->
181
182 <!-- START CONTENT -->
183 <section id="content">
184
185 <!--breadcrumbs start-->
186 <div id="breadcrumbs-wrapper">
187 <div class="container">
188 <div class="row">
189 <div class="col s12 m12 l12">
190 <h5 class="breadcrumbs-title">User List</h5>
191 </div>
192 </div>
193 </div>
194 </div>
195 <!--breadcrumbs end-->
196
197
198 <!--start container-->
199 <div class="container">
200 <p class="caption">Enable, Disable or Verify Users.</p>
201 <div class="divider"></div>
202 <!--editableTable-->
203 <div id="editableTable" class="section">
204 <form class="formValidate" id="formValidate1" method="post" action="routers/user-router.php" novalidate="novalidate">
205 <div class="row">
206 <div class="col s12 m4 l3">
207 <h4 class="header">List of users</h4>
208 </div>
209 <div>
210 <table>
211 <thead>
212 <tr>
213 <th data-field="name">Name</th>
214 <th data-field="price">Email</th>
215 <th data-field="price">Contact</th>
216 <th data-field="price">Address</th>
217 <th data-field="price">Role</th>
218 <th data-field="price">Verified</th>
219 <th data-field="price">Enable</th>
220 <th data-field="price">Wallet</th>
221 </tr>
222 </thead>
223
224 <tbody>
225 <?php
226 $result = mysqli_query($con, "SELECT * FROM users");
227 while($row = mysqli_fetch_array($result))
228 {
229 echo '<tr><td>'.$row["name"].'</td>';
230 echo '<td>'.$row["email"].'</td>';
231 echo '<td>'.$row["contact"].'</td>';
232 echo '<td>'.$row["address"].'</td>';
233 echo '<td><select name="'.$row['id'].'_role">
234 <option value="Administrator"'.($row['role']=='Administrator' ? 'selected' : '').'>Administrator</option>
235 <option value="Customer"'.($row['role']=='Customer' ? 'selected' : '').'>Customer</option>
236 </select></td>';
237 echo '<td><select name="'.$row['id'].'_verified">
238 <option value="1"'.($row['verified'] ? 'selected' : '').'>Verified</option>
239 <option value="0"'.(!$row['verified'] ? 'selected' : '').'>Not Verified</option>
240 </select></td>';
241 echo '<td><select name="'.$row['id'].'_deleted">
242 <option value="1"'.($row['deleted'] ? 'selected' : '').'>Disable</option>
243 <option value="0"'.(!$row['deleted'] ? 'selected' : '').'>Enable</option>
244 </select></td>';
245 $key = $row['id'];
246 $sql = mysqli_query($con,"SELECT * from wallet WHERE customer_id = $key;");
247 if($row1 = mysqli_fetch_array($sql)){
248 $wallet_id = $row1['id'];
249 $sql1 = mysqli_query($con,"SELECT * from wallet_details WHERE wallet_id = $wallet_id;");
250 if($row2 = mysqli_fetch_array($sql1)){
251 $balance = $row2['balance'];
252 }
253 }
254 echo '<td><label for="balance">Balance</label><input id="balance" name="'.$row['id'].'_balance" value="'.$balance.'" type="number" data-error=".errorTxt01"><div class="errorTxt01"></div></td></tr>';
255 }
256 ?>
257 </tbody>
258 </table>
259 </div>
260 <div class="input-field col s12">
261 <button class="btn cyan waves-effect waves-light right" type="submit" name="action">Modify
262 <i class="mdi-content-send right"></i>
263 </button>
264 </div>
265 </div>
266 </form>
267 <form class="formValidate" id="formValidate" method="post" action="routers/add-users.php" novalidate="novalidate">
268 <div class="row">
269 <div class="col s12 m4 l3">
270 <h4 class="header">Add User</h4>
271 </div>
272 <div>
273 <table>
274 <thead>
275 <tr>
276 <th data-field="name">Username</th>
277 <th data-field="name">Password</th>
278 <th data-field="name">Name</th>
279 <th data-field="price">Email</th>
280 <th data-field="price">Phone number</th>
281 <th data-field="price">Address</th>
282 <th data-field="price">Role</th>
283 <th data-field="price">Verified</th>
284 <th data-field="price">Enable</th>
285 </tr>
286 </thead>
287
288 <tbody>
289 <?php
290 echo '<tr><td><label for="username">Username</label><input id="username" name="username" type="text" data-error=".errorTxt02"><div class="errorTxt02"></div></td>';
291 echo '<td><label for="password">Password</label><input id="password" name="password" type="password" data-error=".errorTxt03"><div class="errorTxt03"></div></td>';
292 echo '<td><label for="name">Name</label><input id="name" name="name" type="text" data-error=".errorTxt04"><div class="errorTxt04"></div></td>';
293 echo '<td><label for="email">Email</label><input id="email" name="email" type="email"></td>';
294 echo '<td><label for="contact">Phone number</label><input id="contact" name="contact" type="number" data-error=".errorTxt05"><div class="errorTxt05"></div></td>';
295 echo '<td><label for="address">Address</label><input id="address" name="address" type="text" data-error=".errorTxt06"><div class="errorTxt06"></div></td>';
296 echo '<td><select name="role">
297 <option value="Administrator">Administrator</option>
298 <option value="Customer" selected>Customer</option>
299 </select></td>';
300 echo '<td><select name="verified">
301 <option value="1">Verified</option>
302 <option value="0" selected>Not Verified</option>
303 </select></td>';
304 echo '<td><select name="deleted">
305 <option value="1">Disable</option>
306 <option value="0" selected>Enable</option>
307 </select></td></tr>';
308 ?>
309 </tbody>
310 </table>
311 </div>
312 <div class="input-field col s12">
313 <button class="btn cyan waves-effect waves-light right" type="submit" name="action">Add
314 <i class="mdi-content-send right"></i>
315 </button>
316 </div>
317 </div>
318 </form>
319 <div class="divider"></div>
320
321 </div>
322 </div>
323 </div>
324 <!--end container-->
325
326 </section>
327 <!-- END CONTENT -->
328 </div>
329 <!-- END WRAPPER -->
330
331 </div>
332 <!-- END MAIN -->
333
334
335
336 <!-- //////////////////////////////////////////////////////////////////////////// -->
337
338 <!-- START FOOTER -->
339 <footer class="page-footer">
340 <div class="footer-copyright">
341 <div class="container">
342 <span>Copyright © 2017 <a class="grey-text text-lighten-4" href="#" target="_blank">Students</a> All rights reserved.</span>
343 <span class="right"> Design and Developed by <a class="grey-text text-lighten-4" href="#">Students</a></span>
344 </div>
345 </div>
346 </footer>
347 <!-- END FOOTER -->
348
349
350
351 <!-- ================================================
352 Scripts
353 ================================================ -->
354
355
356 <!-- jQuery Library -->
357 <script type="text/javascript" src="js/plugins/jquery-1.11.2.min.js"></script>
358 <!--angularjs-->
359 <script type="text/javascript" src="js/plugins/angular.min.js"></script>
360 <!--materialize js-->
361 <script type="text/javascript" src="js/materialize.min.js"></script>
362 <!--scrollbar-->
363 <script type="text/javascript" src="js/plugins/perfect-scrollbar/perfect-scrollbar.min.js"></script>
364 <script type="text/javascript" src="js/plugins/jquery-validation/jquery.validate.min.js"></script>
365 <script type="text/javascript" src="js/plugins/jquery-validation/additional-methods.min.js"></script>
366
367
368 <!--plugins.js - Some Specific JS codes for Plugin Settings-->
369 <script type="text/javascript" src="js/plugins.min.js"></script>
370 <!--custom-script.js - Add your own theme custom JS-->
371 <script type="text/javascript" src="js/custom-script.js">
372 $("#formValidate").validate({
373 rules: {
374 username: {
375 required: true,
376 minlength: 5,
377 },
378 password: {
379 required: true,
380 minlength: 5,
381 },
382 name: {
383 required: true,
384 minlength: 5,
385 },
386 contact: {
387 required: true,
388 minlength: 4,
389 },
390 address: {
391 minlength: 10,
392 },
393 balance: {
394 required: true,
395 },
396 },
397 messages: {
398 username:{
399 required: "Enter a username",
400 minlength: "Enter at least 5 characters"
401 },
402 password:{
403 required: "Provide a prove",
404 minlength: "Password must be atleast 5 characters long",
405 },
406 name:{
407 required: "Please provide CVV number",
408 minlength: "Enter at least 5 characters",
409 },
410 contact:{
411 required: "Please provide card number",
412 minlength: "Enter at least 4 digits",
413 },
414 address:{
415 minlength: "Address must be atleast 10 characters long",
416 },
417 balance:{
418 required: "Please provide a balance.",
419 },
420 },
421 errorElement : 'div',
422 errorPlacement: function(error, element) {
423 var placement = $(element).data('error');
424 if (placement) {
425 $(placement).append(error)
426 } else {
427 error.insertAfter(element);
428 }
429 }
430 });
431 </script>
432 </body>
433
434 </html>
435 <?php
436 }
437 else
438 {
439 if($_SESSION['customer_sid']==session_id())
440 {
441 header("location:index.php");
442 }
443 else{
444 header("location:login.php");
445 }
446 }
447 ?>